<!DOCTYPE html>
<html>
<head>
	<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
	<meta name="generator" content="ApiGen 2.8.0" />
	<meta name="robots" content="noindex" />

	<title>File foo-apps/cls/projects.php | foowms</title>

	<script type="text/javascript" src="resources/combined.js?102863017"></script>
	<script type="text/javascript" src="elementlist.js?1046953908"></script>
	<link rel="stylesheet" type="text/css" media="all" href="resources/style.css?3505392360" />

</head>

<body>
<div id="left">
	<div id="menu">
		<a href="index.html" title="Overview"><span>Overview</span></a>


		<div id="groups">
		</div>



		<div id="elements">
			<h3>Classes</h3>
			<ul>
				<li><a href="class-Form.html">Form</a></li>
				<li><a href="class-Paginator.html">Paginator</a></li>
			</ul>





			<h3>Functions</h3>
			<ul>
				<li><a href="function-addResponse.html">addResponse</a></li>
				<li><a href="function-dateDiff.html">dateDiff</a></li>
				<li><a href="function-getCount.html">getCount</a></li>
				<li><a href="function-getCountA.html">getCountA</a></li>
				<li><a href="function-getCountForPanel.html">getCountForPanel</a></li>
				<li><a href="function-getCustomer.html">getCustomer</a></li>
				<li><a href="function-getCustomerInfo.html">getCustomerInfo</a></li>
				<li><a href="function-getCustomers.html">getCustomers</a></li>
				<li><a href="function-getEmployees.html">getEmployees</a></li>
				<li><a href="function-getEngineers.html">getEngineers</a></li>
				<li><a href="function-getName.html">getName</a></li>
				<li class="active"><a href="function-getProjects.html">getProjects</a></li>
				<li><a href="function-getProjectsA.html">getProjectsA</a></li>
				<li><a href="function-getResponseTypes.html">getResponseTypes</a></li>
				<li><a href="function-getReturningStatus.html">getReturningStatus</a></li>
				<li><a href="function-getShipTypes.html">getShipTypes</a></li>
				<li><a href="function-getUOM.html">getUOM</a></li>
				<li><a href="function-getUsers.html">getUsers</a></li>
				<li><a href="function-getUserType.html">getUserType</a></li>
				<li><a href="function-getUserTypeName.html">getUserTypeName</a></li>
				<li><a href="function-getWarehouse.html">getWarehouse</a></li>
				<li><a href="function-getWarehouses.html">getWarehouses</a></li>
				<li><a href="function-getWarehousesCode.html">getWarehousesCode</a></li>
				<li><a href="function-junkRemover.html">junkRemover</a></li>
				<li><a href="function-selectAll.html">selectAll</a></li>
				<li><a href="function-selectAllWhere.html">selectAllWhere</a></li>
				<li><a href="function-selectAllWhereA.html">selectAllWhereA</a></li>
				<li><a href="function-selectAllWhereAA.html">selectAllWhereAA</a></li>
				<li><a href="function-selectAllWhereForPanel.html">selectAllWhereForPanel</a></li>
				<li><a href="function-uomBeauty.html">uomBeauty</a></li>
			</ul>
		</div>
	</div>
</div>

<div id="splitter"></div>

<div id="right">
<div id="rightInner">
	<form id="search">
		<input type="hidden" name="cx" value="" />
		<input type="hidden" name="ie" value="UTF-8" />
		<input type="text" name="q" class="text" />
		<input type="submit" value="Search" />
	</form>

	<div id="navigation">
		<ul>
			<li>
				<a href="index.html" title="Overview"><span>Overview</span></a>
			</li>
			<li>
				<a href="function-getProjects.html" title="Summary of getProjects"><span>Function</span></a>
			</li>
		</ul>
		<ul>
			<li>
				<a href="tree.html" title="Tree view of classes, interfaces, traits and exceptions"><span>Tree</span></a>
			</li>
		</ul>
		<ul>
		</ul>
	</div>

<pre><code><span id="1" class="l"><a class="l" href="#1"> 1: </a><span class="xlang">&lt;?php</span>
</span><span id="2" class="l"><a class="l" href="#2"> 2: </a>
</span><span id="3" class="l"><a class="l" href="#3"> 3: </a><span class="php-comment">/**
</span></span><span id="4" class="l"><a class="l" href="#4"> 4: </a><span class="php-comment"> * @author Samrat Khan &amp; Sadik Sarfaraz - Apr 13, 2013
</span></span><span id="5" class="l"><a class="l" href="#5"> 5: </a><span class="php-comment"> */</span>
</span><span id="6" class="l"><a class="l" href="#6"> 6: </a><span class="php-comment">/**
</span></span><span id="7" class="l"><a class="l" href="#7"> 7: </a><span class="php-comment"> * 
</span></span><span id="8" class="l"><a class="l" href="#8"> 8: </a><span class="php-comment"> * @param string $whereCol Selects from projects which get a column from database.
</span></span><span id="9" class="l"><a class="l" href="#9"> 9: </a><span class="php-comment"> * @param numeric $whereID Selects from projects which get project ID from database.
</span></span><span id="10" class="l"><a class="l" href="#10">10: </a><span class="php-comment"> * @param string $db Database connecting string.
</span></span><span id="11" class="l"><a class="l" href="#11">11: </a><span class="php-comment"> * @return string It returns customerinfo, cusname and cus_id from project table in a variable as $CI.
</span></span><span id="12" class="l"><a class="l" href="#12">12: </a><span class="php-comment"> */</span>
</span><span id="13" class="l"><a class="l" href="#13">13: </a><span class="php-keyword1">function</span> <a id="_getProjectsA" href="#_getProjectsA">getProjectsA</a>(<span class="php-var">$whereCol</span>, <span class="php-var">$whereID</span>, <span class="php-var">$db</span>) {
</span><span id="14" class="l"><a class="l" href="#14">14: </a>    <span class="php-var">$query</span> = <span class="php-quote">&quot;SELECT * FROM projects WHERE </span><span class="php-var">$whereCol</span><span class="php-quote"> = '&quot;</span>.<span class="php-var">$whereID</span>.<span class="php-quote">&quot;'&quot;</span>;
</span><span id="15" class="l"><a class="l" href="#15">15: </a>        <span class="php-keyword1">try</span> {
</span><span id="16" class="l"><a class="l" href="#16">16: </a>            <span class="php-var">$stmt</span> = <span class="php-var">$db</span>-&gt;prepare(<span class="php-var">$query</span>);
</span><span id="17" class="l"><a class="l" href="#17">17: </a>            <span class="php-var">$stmt</span>-&gt;execute();
</span><span id="18" class="l"><a class="l" href="#18">18: </a>        } <span class="php-keyword1">catch</span> (PDOException <span class="php-var">$ex</span>) {
</span><span id="19" class="l"><a class="l" href="#19">19: </a>            <span class="php-keyword1">die</span>(<span class="php-quote">&quot;Failed to run query: &quot;</span> . <span class="php-var">$ex</span>-&gt;getMessage());
</span><span id="20" class="l"><a class="l" href="#20">20: </a>        }
</span><span id="21" class="l"><a class="l" href="#21">21: </a>        <span class="php-var">$rows</span> = <span class="php-var">$stmt</span>-&gt;fetchAll();
</span><span id="22" class="l"><a class="l" href="#22">22: </a>
</span><span id="23" class="l"><a class="l" href="#23">23: </a>        <span class="php-keyword1">foreach</span>(<span class="php-var">$rows</span> <span class="php-keyword1">as</span> <span class="php-var">$row1</span>) {
</span><span id="24" class="l"><a class="l" href="#24">24: </a>            <span class="php-var">$CI</span>.=<span class="php-quote">&quot;&lt;option value='</span><span class="php-var">{$row1[&quot;project_id&quot;]}</span><span class="php-quote">'&gt;&quot;</span>;
</span><span id="25" class="l"><a class="l" href="#25">25: </a>                <span class="php-var">$CI</span>.=<span class="php-var">$row1</span>[<span class="php-quote">'projectname'</span>];
</span><span id="26" class="l"><a class="l" href="#26">26: </a>            <span class="php-var">$CI</span>.=<span class="php-quote">&quot;&lt;/option&gt;&quot;</span>;
</span><span id="27" class="l"><a class="l" href="#27">27: </a>            <span class="php-var">$CI</span>++;
</span><span id="28" class="l"><a class="l" href="#28">28: </a>        }
</span><span id="29" class="l"><a class="l" href="#29">29: </a>        <span class="php-keyword1">return</span> <span class="php-var">$CI</span>;
</span><span id="30" class="l"><a class="l" href="#30">30: </a>}
</span><span id="31" class="l"><a class="l" href="#31">31: </a>
</span><span id="32" class="l"><a class="l" href="#32">32: </a><span class="php-comment">/**
</span></span><span id="33" class="l"><a class="l" href="#33">33: </a><span class="php-comment"> * 
</span></span><span id="34" class="l"><a class="l" href="#34">34: </a><span class="php-comment"> * @param string $whereCol Selects from projects which get a column from database.
</span></span><span id="35" class="l"><a class="l" href="#35">35: </a><span class="php-comment"> * @param numeric $whereID Selects from projects which get project ID from database.
</span></span><span id="36" class="l"><a class="l" href="#36">36: </a><span class="php-comment"> * @param string $db Database connecting string.
</span></span><span id="37" class="l"><a class="l" href="#37">37: </a><span class="php-comment"> * @return string It returns customerinfo, cusname and cus_id from project table in a variable as $CI. Here customer info is concated with project id.
</span></span><span id="38" class="l"><a class="l" href="#38">38: </a><span class="php-comment"> */</span>
</span><span id="39" class="l"><a class="l" href="#39">39: </a><span class="php-keyword1">function</span> <a id="_getProjects" href="#_getProjects">getProjects</a>(<span class="php-var">$whereCol</span>, <span class="php-var">$whereID</span>, <span class="php-var">$db</span>) {
</span><span id="40" class="l"><a class="l" href="#40">40: </a>    <span class="php-var">$query</span> = <span class="php-quote">&quot;SELECT * FROM projects WHERE </span><span class="php-var">$whereCol</span><span class="php-quote"> = '&quot;</span>.<span class="php-var">$whereID</span>.<span class="php-quote">&quot;'&quot;</span>;
</span><span id="41" class="l"><a class="l" href="#41">41: </a>        <span class="php-keyword1">try</span> {
</span><span id="42" class="l"><a class="l" href="#42">42: </a>            <span class="php-var">$stmt</span> = <span class="php-var">$db</span>-&gt;prepare(<span class="php-var">$query</span>);
</span><span id="43" class="l"><a class="l" href="#43">43: </a>            <span class="php-var">$stmt</span>-&gt;execute();
</span><span id="44" class="l"><a class="l" href="#44">44: </a>        } <span class="php-keyword1">catch</span> (PDOException <span class="php-var">$ex</span>) {
</span><span id="45" class="l"><a class="l" href="#45">45: </a>            <span class="php-keyword1">die</span>(<span class="php-quote">&quot;Failed to run query: &quot;</span> . <span class="php-var">$ex</span>-&gt;getMessage());
</span><span id="46" class="l"><a class="l" href="#46">46: </a>        }
</span><span id="47" class="l"><a class="l" href="#47">47: </a>        <span class="php-var">$rows</span> = <span class="php-var">$stmt</span>-&gt;fetchAll();
</span><span id="48" class="l"><a class="l" href="#48">48: </a>
</span><span id="49" class="l"><a class="l" href="#49">49: </a>        <span class="php-keyword1">foreach</span>(<span class="php-var">$rows</span> <span class="php-keyword1">as</span> <span class="php-var">$row1</span>) {
</span><span id="50" class="l"><a class="l" href="#50">50: </a>            <span class="php-var">$CI</span>.=<span class="php-quote">&quot;&lt;option value='</span><span class="php-var">{$row1[&quot;project_id&quot;]}</span><span class="php-quote">'&gt;&quot;</span>;
</span><span id="51" class="l"><a class="l" href="#51">51: </a>                <span class="php-var">$CI</span>.=<span class="php-var">$row1</span>[<span class="php-quote">'projectname'</span>];
</span><span id="52" class="l"><a class="l" href="#52">52: </a>                <span class="php-var">$CI</span>.=<span class="php-quote">&quot; ( &quot;</span>;
</span><span id="53" class="l"><a class="l" href="#53">53: </a>                <span class="php-var">$CI</span>.=getName(<span class="php-quote">'customerinfo'</span>, <span class="php-quote">'cusname'</span>, <span class="php-quote">'cus_id'</span>, <span class="php-var">$row1</span>[<span class="php-quote">'cus_id'</span>], <span class="php-var">$db</span>);
</span><span id="54" class="l"><a class="l" href="#54">54: </a>                <span class="php-var">$CI</span>.=<span class="php-quote">&quot; ) &quot;</span>;
</span><span id="55" class="l"><a class="l" href="#55">55: </a>            <span class="php-var">$CI</span>.=<span class="php-quote">&quot;&lt;/option&gt;&quot;</span>;
</span><span id="56" class="l"><a class="l" href="#56">56: </a>            <span class="php-var">$CI</span>++;
</span><span id="57" class="l"><a class="l" href="#57">57: </a>        }
</span><span id="58" class="l"><a class="l" href="#58">58: </a>        <span class="php-keyword1">return</span> <span class="php-var">$CI</span>;
</span><span id="59" class="l"><a class="l" href="#59">59: </a>}
</span><span id="60" class="l"><a class="l" href="#60">60: </a><span class="xlang">?&gt;</span>
</span><span id="61" class="l"><a class="l" href="#61">61: </a></span></code></pre>

	<div id="footer">
		foowms API documentation generated by <a href="http://apigen.org">ApiGen 2.8.0</a>
	</div>
</div>
</div>
</body>
</html>
